﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage/MasterPage.master" AutoEventWireup="true"
    CodeFile="QueryUseCar.aspx.cs" Inherits="ServicesSheet_QueryUseCar" %>

<%@ Register Assembly="ZLTextBox" Namespace="BaseText" TagPrefix="cc1" %>
<asp:Content ID="Content1" ContentPlaceHolderID="Titile" runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="head" runat="Server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="Content" runat="Server">
    <infolight:webdatasource id="Master" runat="server" autoapply="True" allowadd="True"
        allowdelete="True" allowprint="True" allowupdate="True" alwaysclose="False" autoapplyforinsert="False"
        autorecordlock="False" autorecordlockmode="NoneReload" cachedataset="True" commandname=""
        commandtext="" eof="True" keyvalues="" lastindex="-1" marker="'" masterdatasource=""
        packetrecords="100" quoteprefix="[" quotesuffix="]" remotename="" selectcommand="SELECT Services_SV_Cars.CarName, Services_SV_Cars.CarId, &#13;&#10;      Services_UseCars.EmployeeId, Services_UseCars.UCDate, &#13;&#10;      Services_UseCars.UOutHour, Services_UseCars.UOutMinute, &#13;&#10;      Services_UseCars.UBackHour, Services_UseCars.UBackMinute, &#13;&#10;      Services_UseCars.GetOnAddress, Employees.EmpName, &#13;&#10;      Department.DepartmentName, Services_UseCars.FlowFlag, &#13;&#10;      Services_UseCars.PeoCount, Services_UseCars.PreWay&#13;&#10;FROM Employees INNER JOIN&#13;&#10;      Services_UseCars ON &#13;&#10;      Employees.EmployeeID = Services_UseCars.EmployeeId INNER JOIN&#13;&#10;      Department ON &#13;&#10;      Employees.DepartmentId = Department.DepartmentId RIGHT OUTER JOIN&#13;&#10;      Services_SV_Cars ON Services_UseCars.CarId = Services_SV_Cars.CarId"
        tablename="" selectalias="Usasdb">
    </infolight:webdatasource>
    <infolight:webdatasource id="WebDataSource1" runat="server" selectalias="Usasdb"
        selectcommand="select Services_SV_Cars.CarId,Services_SV_Cars.CarName from Services_SV_Cars"
        cachedataset="True">
    </infolight:webdatasource>
    <table cellpadding="0" cellspacing="5" class="TbSearch">
        <tr>
            <td style="width: 40px">
                <asp:Label ID="Label2" runat="server" Text="日期："></asp:Label>
            </td>
            <td>
                <asp:TextBox ID="QDate" runat="server" onfocus="WdatePicker({dateFmt:'yyyy-M-d'})"
                    Text='' CssClass="Wdate" /></asp:TextBox>
            </td>
            <td style="width: 40px">
                <asp:Label ID="Label1" runat="server" Text="车辆："></asp:Label>
            </td>
            <td style="width: 120px">
                <infolight:webdropdownlist id="WebDropDownList1" runat="server" appenddatabounditems="True"
                    autoinsertemptydata="True" datasourceid="WebDataSource1" datatextfield="CarName"
                    datavaluefield="CarId" driverobject="" filter="" filterobject="" onlyshowselecttext="False">
                </infolight:webdropdownlist>
            </td>
            <td style="width: 64px">
            </td>
            <td>
                <span class="roundbtn">
                    <asp:LinkButton ID="Button1" runat="server" Text="&nbsp;&nbsp;&nbsp;&nbsp;查 询&nbsp;&nbsp;&nbsp;&nbsp;" OnClick="Button1_Click"></asp:LinkButton>
                </span>
            </td>
        </tr>
    </table>
    <infolight:webgridview id="wgvMaster" runat="server" cellpadding="5" forecolor="#333333"
        width="100%" aborticonurl="../Image/UIPics/Abort.gif" addiconurl="../Image/UIPics/Add.gif"
        applyiconurl="../Image/UIPics/Apply.gif" canceliconurl="../Image/UIPics/Cancel.gif"
        mouseoveraborticonurl="../Image/UIPics/Abort2.gif" mouseoveraddiconurl="../Image/UIPics/Add2.gif"
        mouseoverapplyiconurl="../Image/UIPics/Apply2.gif" mouseovercanceliconurl="../Image/UIPics/Cancel2.gif"
        mouseoverokiconurl="../Image/UIPics/OK2.gif" mouseoverqueryiconurl="../Image/UIPics/Query2.gif"
        okiconurl="../Image/UIPics/OK.gif" queryiconurl="../Image/UIPics/Query.gif" headerstylewrap="False"
        backcolor="White" bordercolor="White" borderstyle="Groove" borderwidth="2px"
        useaccessibleheader="False" allowpaging="False">
        <pagersettings mode="NumericFirstLast" />
        <footerstyle backcolor="#507CD1" forecolor="White" font-bold="True"></footerstyle>
        <navcontrols>
<InfoLight:ControlItem ControlVisible="True" Size="25" MouseOverImageUrl="../image/uipics/add2.gif" ControlText="add" ControlName="Add" ControlType="Image" ImageUrl="../image/uipics/add.gif"></InfoLight:ControlItem>
<InfoLight:ControlItem ControlVisible="True" Size="25" MouseOverImageUrl="../image/uipics/ok2.gif" ControlText="Insert" ControlName="OK" ControlType="Image" ImageUrl="../image/uipics/ok.gif"></InfoLight:ControlItem>
<InfoLight:ControlItem ControlVisible="True" Size="25" MouseOverImageUrl="../image/uipics/cancel2.gif" ControlText="cancel" ControlName="Cancel" ControlType="Image" ImageUrl="../image/uipics/cancel.gif"></InfoLight:ControlItem>
</navcontrols>
        <columns>
               <asp:BoundField DataField="CarId" HeaderText="车辆编号" SortExpression="CarId" />
                <asp:BoundField DataField="CarName" HeaderText="车辆名称" SortExpression="CarName" />
                <asp:BoundField DataField="EmployeeId" HeaderText="工号" SortExpression="EmployeeId" />
                <asp:BoundField DataField="EmpName" HeaderText="姓名" SortExpression="EmpName" />
                <asp:BoundField DataField="DepartmentName" HeaderText="部门" SortExpression="DepartmentName" >
                    <itemstyle horizontalalign="Center" />
                    <headerstyle horizontalalign="Center" />
                </asp:BoundField>
                <asp:BoundField DataField="UCDate" HeaderText="日期" SortExpression="UCDate" DataFormatString="{0:d}" HtmlEncode="False" >
                    <itemstyle horizontalalign="Center" />
                    <headerstyle horizontalalign="Center" />
                </asp:BoundField>
                 <asp:BoundField DataField="PeoCount" HeaderText="乘车人数" SortExpression="PeoCount" >
                     <itemstyle horizontalalign="Center" />
                 </asp:BoundField>
                <asp:BoundField DataField="UCTime" HeaderText="时间" SortExpression="UCTime" >
                    <itemstyle horizontalalign="Center" />
                    <headerstyle horizontalalign="Center" />
                </asp:BoundField>
                 <asp:BoundField DataField="FlowFlag" HeaderText="审核状态" SortExpression="FlowFlag" />
                  <asp:BoundField DataField="PreWay" HeaderText="预计行驶路线" SortExpression="PreWay" />
</columns>
        <rowstyle backcolor="#EFF3FB"></rowstyle>
        <editrowstyle backcolor="#2461BF"></editrowstyle>
        <selectedrowstyle backcolor="#D1DDF1" forecolor="#333333" font-bold="True"></selectedrowstyle>
        <pagerstyle backcolor="LightBlue" forecolor="White" horizontalalign="Center"></pagerstyle>
        <headerstyle backcolor="DeepSkyBlue" forecolor="White" font-bold="True"></headerstyle>
        <alternatingrowstyle backcolor="White" bordercolor="White"></alternatingrowstyle>
        <emptydatatemplate>
                <asp:Label ID="Label3" runat="server" ForeColor="Red" Text="没有人申请用车！"></asp:Label>
            </emptydatatemplate>
    </infolight:webgridview>
</asp:Content>
